use master
go
create database fwcz
on
(
name= 'fwcz',
filename = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\fwcz.mdf',
size =5,
maxsize=10,
filegrowth =10%


)

log on
(
name= 'fwcz_log',
filename = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\fwcz_log.ldf',
size =5,
maxsize=10,
filegrowth =10%

)
go
use fwcz
go

create table tblUser 
(
userId int ,
userName varchar(20),
usertel varchar(20),

)
create table tblHouseType
(
typeId int,
typName varchar(10),


)
create table tblQX
(
qxld int,
qcname varchar(10)

)
create table tblHouseInfo
(
id int,


)
create table descc
(
useld int,
zj varchar(10),
shi varchar(10),
ting varchar(10),
ting varchar(10),
typeld varchar(10),
qxld varchar(10)
)